2014-09-16 - 10735.2500 - Spec - Update OSA900 to add groups for Japan #CrystalReportsSupport
SPECIFICATIONS
10735.2500 - Spec - Update OSA900 to add groups for Japan
Purpose
1. Need the following groups added for Japan to evaluate their programs.
- Sales Org > Sales Rep > Customer > Collection
- Sales Org > Sales Rep > Collection
- Sales Org > Collection
2. For all groups add the functionality to display without drilldown after the Sales Org is selected (if possible) and if not then to display all without drilldown.
Admin Info
Purpose
|
Update OSA900 to add groups for Japan.
|
Requested By
|
Mark Harris
|
Spec Created By
|
Praveen Guntuka
|
Spec Created Date
|
09/16/2014
|
Spec QA by
|
Uday P
|
Objects
|
OSA900 - Open Orders by Sales Org, SBU, Sales Rep, Customer, Season and Collection
|
Document Status
|
Completed
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
00
|
2
|
Documentation
|
04
|
3
|
Development/ Config
|
10
|
4
|
Unit test in DEV
|
01
|
5
|
Unit test in QUA
|
01
|
6
|
Other activity
|
00
|
|
TOTAL
|
16
|
References
Prior Tickets
None
Documents
None
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
1
|
Add a parameter to Drill down / Without Drill Down and show all the groups from second level when the parameter values is Without Drill down
|
Mark Harris
|
09/15/2014
|
None
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
NEC is adding Japan data to SAP and part of that project is to pull Japan data into the reports from SAP.
In Scope:
1. Need to add the groupings suggested by NEC in OSA900 report.
2. Need to add a parameter for Drill Down/Without Drill Down in the report.
Out of Scope:
Other Sales Analysis reports.
Solution Summary
1. Need to add the new grouping in OSA900 production report.
2. Need to Create a parameter to show/ hide grouping in the report.
Test Plan
Test ID
|
Test Scenario
|
Expected Results
|
1
|
Report Format.
|
Should be as per NEC crystal standard checklist.
|
2
|
Execute Crystal Report in Crystal Designer tool after changes.
|
Report should execute successfully in Crystal Designer tool.
|
3
|
Schedule the Report in NEC BI Launch Pad.
|
Report should execute successfully in NEC BI Launch Pad.
|
Solution Details
1. Need to add the new grouping order in OSA900 report.
2. Need to change the respective grouping formulas in the report.
3. Need to include the changes in Title and Parameter text formulas in the report.
4. Need to create a parameter with 'With Drill Down' and 'Without Drill Down' values.
5. Based on the parameter values need to show or hide the groupings in the report.
6. Need to change the group drill down color according to drill down and grouping parameter values.
Issues
None